package com.example.springboot.modules.test.service.impl;

import com.baomidou.mybatisplus.core.conditions.update.UpdateWrapper;
import com.example.springboot.modules.common.vo.Result;
import com.example.springboot.modules.common.vo.Search;
import com.example.springboot.modules.test.dao.CityDao;
import com.example.springboot.modules.test.dao.CityDao2;
import com.example.springboot.modules.test.entity.City;
import com.example.springboot.modules.test.service.CityService;
import com.github.pagehelper.PageHelper;
import com.github.pagehelper.PageInfo;
import net.sf.jsqlparser.statement.create.schema.CreateSchema;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.stereotype.Service;
import org.springframework.transaction.annotation.Transactional;

import java.util.*;

@Service
public class CityServiceImpl implements CityService {
    @Autowired
    private CityDao cityDao;
    @Autowired
    private CityDao2 cityDao2;

    @Override
    @Transactional
    public Result<City> insertCity(City city) {
        City temp=cityDao.getCityByCityName(city.getCityName());
        if (temp !=null){
            return new Result<>(Result.ResultStatus.FAILD.code,"City name is repead.");
        }

        city.setDateCreated(new Date());
        city.setDateModified(new Date());
//        cityDao.insertCity(city);
        cityDao2.insert(city);
        return new Result<>(Result.ResultStatus.SUCCESS.code,"Insert success.",city);
    }

    @Override
    public Result<City> updateCity(City city) {
        City temp=cityDao.getCityByCityName(city.getCityName());
        if (temp !=null && temp.getCityId()!=city.getCityId()){
            return new Result<>(Result.ResultStatus.FAILD.code,"City name is repead.");
        }
        city.setDateModified(new Date());
//        cityDao.updateCity(city);
//        cityDao2.updateById(city);
        UpdateWrapper wrapper=new UpdateWrapper();
        wrapper.set(true,"city_name",city.getCityName());
        wrapper.set(true,"local_city_name",city.getLocalCityName());
        wrapper.eq(true,"city_id",city.getCityId());
        cityDao2.update(city,wrapper);
        return new Result<>(Result.ResultStatus.SUCCESS.code,"Update success.",city);
    }

    @Override
    @Transactional
    public Result<Object> deleteCityByCityId(int cityId){
//        cityDao.deleteCityByCityId(cityId);
        cityDao2.deleteById(cityId);
//        Map<String,Object> columnMap=new HashMap<>();
//        columnMap.put("city_id",cityId);
//        cityDao2.deleteByMap(columnMap);
        return new Result<>(Result.ResultStatus.SUCCESS.code,"Delete success");
    }

    @Override
    public City getCityByCityId(int cityId) {
//        return cityDao.getCityByCityId(cityId);
        return cityDao2.selectById(cityId);
    }

    @Override
    public City getCityByNames(String cityName, String localCityName) {
        return cityDao.getCityByNames(cityName,localCityName);
    }

    @Override
    public List<City> getCitiesByCountryId(int countryId){
        return Optional
                .ofNullable(cityDao.getCitiesByCountryId(countryId))
                .orElse(Collections.emptyList());
    }

    @Override
    public PageInfo<City> getCitiesBySearch(Search search){
        //初始化 seach 对象
        search.init();
        //开始分页
        PageHelper.startPage(search.getCurrentPage(),search.getPageSize());
        //返回分页对象
        return new PageInfo<>(Optional
                .ofNullable(cityDao.getCitiesBySearch(search))
                .orElse(Collections.emptyList()));
    }
}
